<?xml version="1.0" encoding="utf-8" ?>

<!-- Description         :  The description/title of the stored procedure
      RestrictedTo        :  Will only show as an option to the corresponding users
                                "9" - Available to everyone
      StoredProcedureName :  The name of the stored procedure 
      UseXSLTFile        :  true/false - If true a file with the same name needs to exist in the folder with extension xslt.
     
      
      Notes  1. Passing userId - To pass the user id logged in the application to the stored procedure 
                                         create a parameter of userId in the stored procedure.  You do not have 
                                       to specify that in the criteria list. 
      -->
<report Description="Progress Report Deliverables Master" LongDescription="Progress Report Deliverables Master Report"  RestrictedTo="524288" StoredProcedureName="" ReportingServicesReportName="ProgressReportDeliverablesMaster" UseXSLTFile="false">

	<textcriteria Description="DomainUserId" ParameterName="DomainUserId" IsVisible="false" IsRequired="false" Type="text"/>
	<textcriteria Description="Due Date (From)" ParameterName="StartDate" IsVisible="true" IsRequired="true" Type="date"/>
	<textcriteria Description="Due Date (To)" ParameterName="EndDate" IsVisible="true" IsRequired="true" Type="date"/>

	<dropdowncriteria Description="Institution" ParameterName="Institution" PopulateFrom="GetInstitutions" ValueColumn="InstitutionId" TextColumn="Description" IsRequired="true" DisplayAllChoice="true"/>
	<listboxcriteria Height="100" SelectionMode="Single" Description="Department" ParameterName="Department" PopulateFrom="GetDepartments" ValueColumn="DeptId" TextColumn="DepartmentChiefCode" IsRequired="false" DisplayAllChoice="true" DependsOnControlParameterName="Institution" DefaultValue=""/>
	<listboxcriteria Height="100" SelectionMode="Multi" Description="Unit" ParameterName="Unit" PopulateFrom="GetUnits" ValueColumn="UnitId" TextColumn="Unit" IsRequired="false" DisplayAllChoice="true" DependsOnControlParameterName="Department" DefaultValue="0"  />

	<textcriteria Description="Fund #s (separate by commas)" ParameterName="FundNumber" IsVisible="true" IsRequired="false" Type="text"/>
	<listboxcriteria Height="100" SelectionMode="Single" Description="Principal Investigator" ParameterName="PrincipalInvestigator" PopulateFrom="GetPrincipalInvestigators" ValueColumn="PIId" TextColumn="PIName" IsRequired="false" DisplayAllChoice="true" DependsOnControlParameterName="Institution" DefaultValue="0" SearchParameterName="Name" />
	<listboxcriteria Height="100" SelectionMode="Single" Description="Sponsor" ParameterName="Sponsor" PopulateFrom="GetRptSponsors" ValueColumn="SponsorId" TextColumn="ShortName" IsRequired="false" DisplayAllChoice="true" DefaultValue="0" SearchParameterName="Name" />
	<listboxcriteria Height="100" SelectionMode="Single" Description="Originating Sponsor" ParameterName="OriginatingSponsor" PopulateFrom="GetSecondarySponsors" ValueColumn="Name" TextColumn="Name" IsRequired="false" DisplayAllChoice="true" DefaultValue="0" SearchParameterName="Name" />

	<listboxcriteria Height="100" SelectionMode="Single" Description="RM Staff Member" ParameterName="SubcontractSpecialist" PopulateFrom="GetSubContractSpecialists" ValueColumn="SubContractSpecialist" TextColumn="SubContractSpecialist" IsRequired="false" DependsOnControlParameterName="Institution" DisplayAllChoice="true" DefaultValue="0" SearchParameterName="Name" />

	<listboxcriteria Height="100" SelectionMode="Multi" Description="Deliverable Status" ParameterName="DeliverableStatus" PopulateFrom="GetDeliverableStatusesForProgressMaster" ValueColumn="DELSTAT" TextColumn="DELSTATDESC" IsRequired="true" DisplayAllChoice="false" DefaultValue="ALL" />

	<dropdowncriteria Description="Group By" ParameterName="GroupBy" PopulateFrom="GetSubContractGroupByCodes"  PopulateFromStaticParamValues="Report=RptSubContractWrapperReport,IncludeSubContr=No"  ValueColumn="GroupByCode" TextColumn="GroupByName" IsRequired="true" DisplayAllChoice="false" DefaultValue="ORG"/>

</report>